Microsoft Excel Q/a Practice Questions Answers Test With Solutions & More Shortcuts

Question : 16

In Excel which is not an advantage of using computerized spreadsheets?

a) Flexibility of moving entries

b) Speed of calculation

c) Ability of generate tables

d) Cost of initial setup

Question : 17

To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called

a) HTML

b) Pivot Table Field List

c) Pivot Table List

d) Pivot Table Report

e) None of these

Question : 18

A function incite another function is called a .....function.

a) Nested

b) Round

c) Sum

d) Text

e) None of these

Question : 19

Where a row and a column meet, what do you call that?

a) A eel I

b) A block

c) A box

d) All of the above

e) None of these

Question : 20

Which of the following is the latest version of Excel?

a) Excel 2000

b) Excel 20.02

c) Excel ME

d) Excel XP

e) None of these